from sqlalchemy import Column, String, Integer, ForeignKey, create_engine
from sqlalchemy.orm import sessionmaker  , relationship
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()


class Option(Base):
    __tablename__ = 'option'
    option_id = Column(Integer, primary_key=True)
    option_sequence = Column(Integer)
    option_name = Column(String(20))
    questnr_id = Column(Integer )
    option_alpha = Column(String)

class Questnr(Base):
    __tablename__ = 'questnr'

    questnr_id = Column(Integer , primary_key=True)
    questnr_name = Column(String(20))

class Answer(Base):
    __tablename__ = 'answer'

    question_id = Column(Integer , primary_key=True)
    answer_alpha = Column(String(20))

